/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 50710
 Source Host           : localhost:3306
 Source Schema         : crud-demo

 Target Server Type    : MySQL
 Target Server Version : 50710
 File Encoding         : 65001

 Date: 28/11/2021 20:00:50
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` varchar(20) NOT NULL COMMENT '部门id',
  `parent_id` varchar(20) DEFAULT '0' COMMENT '父部门id',
  `ancestors` varchar(50) DEFAULT '' COMMENT '祖级列表',
  `dept_name` varchar(30) DEFAULT '' COMMENT '部门名称',
  `order_num` varchar(4) DEFAULT '0' COMMENT '显示顺序',
  `leader` varchar(20) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `status` varchar(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `del_flag` varchar(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` varchar(255) DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` varchar(255) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES ('100', '0', '0', '若依科技', '0', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-11-16 14:30:21', '', NULL);
INSERT INTO `sys_dept` VALUES ('101', '100', '0,100', '深圳总公司', '1', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-11-16 14:30:21', '', NULL);
INSERT INTO `sys_dept` VALUES ('102', '100', '0,100', '长沙分公司', '2', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-11-16 14:30:21', '', NULL);
INSERT INTO `sys_dept` VALUES ('103', '101', '0,100,101', '研发部门', '1', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-11-16 14:30:21', '', NULL);
INSERT INTO `sys_dept` VALUES ('104', '101', '0,100,101', '市场部门', '2', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-11-16 14:30:21', '', NULL);
INSERT INTO `sys_dept` VALUES ('105', '101', '0,100,101', '测试部门', '3', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-11-16 14:30:21', '', NULL);
INSERT INTO `sys_dept` VALUES ('106', '101', '0,100,101', '财务部门', '4', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-11-16 14:30:21', '', NULL);
INSERT INTO `sys_dept` VALUES ('107', '101', '0,100,101', '运维部门', '5', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-11-16 14:30:21', '', NULL);
INSERT INTO `sys_dept` VALUES ('108', '102', '0,100,102', '市场部门', '1', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-11-16 14:30:21', '', NULL);
INSERT INTO `sys_dept` VALUES ('109', '102', '0,100,102', '财务部门', '2', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-11-16 14:30:21', '', NULL);
INSERT INTO `sys_dept` VALUES ('200', '100', '0,100', '123', '1', NULL, NULL, NULL, '0', '2', 'admin', '2021-11-16 17:08:17', '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) NOT NULL COMMENT '菜单名称',
  `parent_id` varchar(20) DEFAULT '0' COMMENT '父菜单ID',
  `order_num` varchar(4) DEFAULT '0' COMMENT '显示顺序',
  `path` varchar(200) DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) DEFAULT NULL COMMENT '组件路径',
  `query` varchar(255) DEFAULT NULL COMMENT '路由参数',
  `is_frame` varchar(1) DEFAULT '1' COMMENT '是否为外链（0是 1否）',
  `is_cache` varchar(1) DEFAULT '0' COMMENT '是否缓存（0缓存 1不缓存）',
  `menu_type` varchar(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` varchar(1) DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` varchar(1) DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` varchar(255) DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` varchar(255) DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1021 DEFAULT CHARSET=utf8 COMMENT='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, '系统管理', '0', '1', 'system', '', '', '1', '0', 'M', '0', '0', '', 'system', 'admin', '2021-11-16 14:30:21', '刘一手', NULL, '系统管理目录');
INSERT INTO `sys_menu` VALUES (100, '用户管理', '1', '1', 'user', 'system/user/index', '', '1', '0', 'C', '0', '0', 'system:user:list', 'user', 'admin', '2021-11-16 14:30:21', '', NULL, '用户管理菜单');
INSERT INTO `sys_menu` VALUES (101, '角色管理', '1', '2', 'role', 'system/role/index', '', '1', '0', 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2021-11-16 14:30:21', '', NULL, '角色管理菜单');
INSERT INTO `sys_menu` VALUES (102, '菜单管理', '1', '3', 'menu', 'system/menu/index', '', '1', '0', 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2021-11-16 14:30:21', '', NULL, '菜单管理菜单');
INSERT INTO `sys_menu` VALUES (103, '部门管理', '1', '4', 'dept', 'system/dept/index', '', '1', '0', 'C', '1', '0', 'system:dept:list', 'tree', 'admin', '2021-11-16 14:30:21', '刘一手', NULL, '部门管理菜单');
INSERT INTO `sys_menu` VALUES (1001, '用户查询', '100', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:user:query', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1002, '用户新增', '100', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:user:add', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1003, '用户修改', '100', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:user:edit', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1004, '用户删除', '100', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:user:remove', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1005, '用户导出', '100', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:user:export', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1006, '用户导入', '100', '6', '', '', '', '1', '0', 'F', '0', '0', 'system:user:import', '#', 'admin', '2021-11-16 14:30:21', '刘一手', NULL, '');
INSERT INTO `sys_menu` VALUES (1007, '重置密码', '100', '7', '', '', '', '1', '0', 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1008, '角色查询', '101', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:role:query', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1009, '角色新增', '101', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:role:add', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1010, '角色修改', '101', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:role:edit', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1011, '角色删除', '101', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:role:remove', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1012, '角色导出', '101', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:role:export', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1013, '菜单查询', '102', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:query', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1014, '菜单新增', '102', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:add', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1015, '菜单修改', '102', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1016, '菜单删除', '102', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1017, '部门查询', '103', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:query', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1018, '部门新增', '103', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:add', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1019, '部门修改', '103', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1020, '部门删除', '103', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2021-11-16 14:30:21', '', NULL, '');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) DEFAULT NULL COMMENT '角色权限字符串',
  `role_sort` varchar(4) NOT NULL COMMENT '显示顺序',
  `data_scope` varchar(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `menu_check_strictly` varchar(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示',
  `dept_check_strictly` varchar(1) DEFAULT '1' COMMENT '部门树选择项是否关联显示',
  `status` varchar(1) NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` varchar(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` varchar(255) DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` varchar(255) DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8 COMMENT='角色信息表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '超级管理员', 'admin', '1', '1', '1', '1', '0', '0', 'admin', '2021-11-16 14:30:21', '', NULL, '超级管理员');
INSERT INTO `sys_role` VALUES (2, '普通角色', 'common', '2', '2', '1', '1', '0', '0', 'admin', '2021-11-16 14:30:21', '刘一手', '1638014188645', '普通角色');
INSERT INTO `sys_role` VALUES (100, 'test01', 'admin1', '3', '1', '1', '0', '0', '0', 'admin', '2021-11-16 17:04:35', '刘一手', '1638014569034', '');
INSERT INTO `sys_role` VALUES (101, 'test011', NULL, '4', '1', '1', '1', '1', '0', '', '1637807449288', '刘一手', '1638100058678', '');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept` (
  `role_id` varchar(20) NOT NULL COMMENT '角色ID',
  `dept_id` varchar(20) NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`,`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色和部门关联表';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_dept` VALUES ('2', '100');
INSERT INTO `sys_role_dept` VALUES ('2', '101');
INSERT INTO `sys_role_dept` VALUES ('2', '105');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` varchar(20) NOT NULL COMMENT '角色ID',
  `menu_id` varchar(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色和菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES ('100', '1');
INSERT INTO `sys_role_menu` VALUES ('100', '100');
INSERT INTO `sys_role_menu` VALUES ('100', '1001');
INSERT INTO `sys_role_menu` VALUES ('100', '1002');
INSERT INTO `sys_role_menu` VALUES ('100', '1003');
INSERT INTO `sys_role_menu` VALUES ('100', '1004');
INSERT INTO `sys_role_menu` VALUES ('100', '1005');
INSERT INTO `sys_role_menu` VALUES ('100', '1006');
INSERT INTO `sys_role_menu` VALUES ('100', '1007');
INSERT INTO `sys_role_menu` VALUES ('100', '1008');
INSERT INTO `sys_role_menu` VALUES ('100', '1009');
INSERT INTO `sys_role_menu` VALUES ('100', '101');
INSERT INTO `sys_role_menu` VALUES ('100', '1010');
INSERT INTO `sys_role_menu` VALUES ('100', '1011');
INSERT INTO `sys_role_menu` VALUES ('100', '1012');
INSERT INTO `sys_role_menu` VALUES ('100', '1013');
INSERT INTO `sys_role_menu` VALUES ('100', '1014');
INSERT INTO `sys_role_menu` VALUES ('100', '1015');
INSERT INTO `sys_role_menu` VALUES ('100', '1016');
INSERT INTO `sys_role_menu` VALUES ('100', '1017');
INSERT INTO `sys_role_menu` VALUES ('100', '1018');
INSERT INTO `sys_role_menu` VALUES ('100', '1019');
INSERT INTO `sys_role_menu` VALUES ('100', '102');
INSERT INTO `sys_role_menu` VALUES ('100', '1020');
INSERT INTO `sys_role_menu` VALUES ('100', '103');
INSERT INTO `sys_role_menu` VALUES ('2', '1');
INSERT INTO `sys_role_menu` VALUES ('2', '100');
INSERT INTO `sys_role_menu` VALUES ('2', '1001');
INSERT INTO `sys_role_menu` VALUES ('2', '1002');
INSERT INTO `sys_role_menu` VALUES ('2', '1003');
INSERT INTO `sys_role_menu` VALUES ('2', '1004');
INSERT INTO `sys_role_menu` VALUES ('2', '1005');
INSERT INTO `sys_role_menu` VALUES ('2', '1006');
INSERT INTO `sys_role_menu` VALUES ('2', '1007');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `dept_id` varchar(20) DEFAULT NULL COMMENT '部门ID',
  `user_account` varchar(30) NOT NULL COMMENT '用户账号',
  `user_name` varchar(30) NOT NULL COMMENT '用户姓名',
  `user_type` varchar(2) DEFAULT '00' COMMENT '用户类型（00系统用户）',
  `email` varchar(50) DEFAULT '' COMMENT '用户邮箱',
  `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码',
  `sex` varchar(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) DEFAULT '' COMMENT '头像地址',
  `password` varchar(100) DEFAULT '' COMMENT '密码',
  `status` varchar(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` varchar(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `login_ip` varchar(128) DEFAULT '' COMMENT '最后登录IP',
  `login_date` varchar(255) DEFAULT NULL COMMENT '最后登录时间',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` varchar(255) DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` varchar(255) DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 COMMENT='用户信息表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, '103', 'admin', '渣渣灰', '00', 'zzh@163.com', '15888888888', '0', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2021-11-16 16:58:48', 'admin', '1637307631077', '', '1637307631077', '管理员');
INSERT INTO `sys_user` VALUES (2, '105', 'ry', '渣渣灰', '00', 'zzh@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2021-11-16 14:30:21', 'admin', '1637407600685', '刘一手', '1638003171337', '测试员');
INSERT INTO `sys_user` VALUES (100, '0', '666', 'string', '1', 'strin1g3@qq.com', '13242343521', '0', '', 'string', '0', '1', '', '', '刘一手', '1637716206525', '刘一手', '1637716206525', 'string');
INSERT INTO `sys_user` VALUES (101, '0', '111', '', '1', '', '', '2', '', '$2a$10$z5kSoKWQ1iqVuFBbyMsJBOR4JhmaGbinamvyG9kS8Nlm4xM0G.4hW', '1', '1', '', '', '刘一手', '1637118028434', '', '1637118028434', '');
INSERT INTO `sys_user` VALUES (104, NULL, '1234', '刘一手', '00', '8786243271@qq.com', '13242342312', '0', '', '$2a$10$bnUpbgvlK/Gei8KQdOvEHOGydTUtoJhRTlYLeTnXLyoNfGc7v2ZFi', '0', '0', '', NULL, '刘一手', '1637307714969', '刘一手', '1637307714969', NULL);
INSERT INTO `sys_user` VALUES (105, NULL, '31242', '刘一手', '00', '878624379@qq.com', '13241234214', '0', '', '$2a$10$4Eej3ER7GeQlWPM2ih8qR.eiLta2Nv7EhUqs5sUAkrYVAg9x.NCwm', '0', '0', '', NULL, '刘一手', '1637407743549', '刘一手', '1637807001572', NULL);
INSERT INTO `sys_user` VALUES (106, NULL, 'user01', '刘一手', '00', '', '', '0', '', '$2a$10$TCdtDdSmPUpdECZiV02E3u25iAVqQ7HQCxNKrRvpIpaMUE9gtoV0W', '1', '0', '', NULL, '刘一手', '1638013433030', '刘一手', '1638100750028', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` varchar(20) NOT NULL COMMENT '用户ID',
  `role_id` varchar(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户和角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES ('1', '1');
INSERT INTO `sys_user_role` VALUES ('1', '101');
INSERT INTO `sys_user_role` VALUES ('100', '101');
INSERT INTO `sys_user_role` VALUES ('104', '101');
INSERT INTO `sys_user_role` VALUES ('105', '101');
INSERT INTO `sys_user_role` VALUES ('106', '2');
INSERT INTO `sys_user_role` VALUES ('118', '100');
INSERT INTO `sys_user_role` VALUES ('118', '2');
INSERT INTO `sys_user_role` VALUES ('2', '101');
INSERT INTO `sys_user_role` VALUES ('2', '2');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
